﻿	CREATE TABLE public.environment_resource
	(
	    /***************************************************************************************************
	    **  Table:	    public.environment_resource
	    **  Author:		Zhixian Ong
	    **
	    **  Description:
	    **    
	    **    List of registered environment resource.
        **    Mapping environment to resources
	    **
	    **  Fields (2):
	    **
	    **      environment_id  -
	    **      resource_id     -
	    **
	    **  Constaints (1):
	    **
	    **      environment_resource_pk - 
	    **      
	    **
	    **  Modification History:
	    **
	    **      20140102  Zhixian Ong     - Initial prototype
	    ** 
	    **  Status:
	    **
	    **      Dev
	    ** 
	    ***************************************************************************************************/
        
	    -- [Fields]
	    environment_id  integer                 NOT NULL,
	    resource_id     integer                 NOT NULL,
        
	    -- [Constraints]
	    CONSTRAINT environment_resource_pk PRIMARY KEY (environment_id, resource_id)
	);
	